<%@ page import="java.sql.*" %>
<html>

<body bgcolor="#fdfec5">
<center><img src="images/7.jpeg" border=0 width=263 height=128>
<br><br><br>
<center><font color="#1589FF" size="5"><b><i><u>Balance Details Of Customer</u></i></b></font></center><br><br>
<%
try
{
		//String p=(String);
 // int accno1=Integer.parseInt(p);
 // System.out.println(accno1);
  Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","bank","bank");
  Statement st=con.createStatement();
 ResultSet rs=st.executeQuery("select  name,accno  from customer where accno!="+session.getAttribute("pin")+" ");
 %>
 <center><form method=post action="Sucesstrans.jsp">
 
	To Account Holder: <select name="n">
 System.out.println(rs);%>	 	
	 <%
		 	while(rs.next())
	    	  {
		%>
	<option value=<%= rs.getString(2)%>><%= rs.getString(1) %></option>
    <%}
		%>
		</select><br><br>Amount: <input type=text name="am">
<br><input type=submit value="Send">&nbsp;&nbsp;
		<%
    st.close();
    rs.close();
    con.close(); 
    %>
   </form>
    <%}
   		catch(Exception e)
	{
	System.out.println(e);
	}
%>
